Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# maintSpec

Syntax

maintSpec::=

Description of the illustration maintspec.gif

Purpose

To specify the backup files operated on by the `CHANGE`, `CROSSCHECK`, and `DELETE` commands.

Keywords and Parameters

Syntax Element | Description
--- | ---
`BACKUP` | Processes files output by the `BACKUP` command. With CHANGE BACKUP: Specify one or more objects using the "`CHANGE BACKUP OF` `listObjList`" form of the command. Otherwise, CHANGE BACKUP operates on all backup sets, image copies, and proxy copies recorded in the repository. With CROSSCHECK `BACKUP`: If you are running CROSSCHECK `BACKUP`, then the command crosschecks `BACKUP` output that has status `AVAILABLE` or `EXPIRED`: backup sets (including backup pieces), proxy copies, and image copies. RMAN crosschecks all backups not marked `UNAVAILABLE`, even if they cannot be restored or if they are incremental backups whose parent full backup or copy no longer exists. Specify one or more objects using the "`CROSSCHECK BACKUP` `OF` `listObjList`" form of the command. Otherwise, RMAN crosschecks backups of the whole database. With DELETE BACKUP: Deletes backup sets and proxy copies. Specify one or more objects using the "`DELETE BACKUP` `OF` `listObjList`" form of the command. Otherwise, RMAN deletes backup sets of the whole database.
`BACKUPSET` | When followed by a list of primary keys: this is actually a case of the `recordSpec` syntax element in the syntax diagram for maintSpec. In such a case, the keys identify backupsets for use with the `CHANGE`, `CROSSCHECK` and `DELETE` commands. For more details, see "recordSpec" and "LIST Output" for an explanation of the column headings of the `LIST` output tables. Use the `KEY` column of the output to obtain the primary key usable in the `CHANGE` and `DELETE` commands. When not followed by a list of primary keys: A synonym for `BACKUP`.
`COPY` | Processes datafile copies, control file copies, archived redo logs, and image copies of archived redo logs. If you do not specify an option for CHANGE `COPY`, then the command operates on all image copies recorded in the repository. If you are running CROSSCHECK `COPY`, then by default the command checks all image copies of all files in the database with status `AVAILABLE` or `EXPIRED`. By default, `COPY` removes copies of all files in the database. Specify the `EXPIRED` option to remove only copies that are marked `EXPIRED` in the repository.
`OF` listObjList | Restricts the list of objects operated on to the object type specified in the `listObjList` clause. If you do not specify an object, then the command defaults to all copies. Note that `CHANGE` `COPY` `OF` `DATABASE` includes datafiles but not control files. See Also: "listObjList"
archivelogRecordSpecifier | Processes the specified archived redo logs. See Also: "archivelogRecordSpecifier"
maintQualifier | Restricts the command based on the specified options. See Also: "maintQualifier"
recordSpec | Specifies the file that you are performing maintenance on. See "recordSpec".
`DEVICE` `TYPE` deviceSpecifier | Allocates automatic channels for the specified device type only. This option is valid only if you have configured automatic channels and have not manually allocated channels. For example, if you configure automatic disk and tape channels and run `CROSSCHECK``...``DEVICE` `TYPE` `DISK`, then RMAN allocates only disk channels. See Also: "deviceSpecifier"

Examples

To see the `maintSpec` clause in use, refer to the commands where it is used:

- "CHANGE"

- "CROSSCHECK"

- "DELETE"